﻿CREATE proc NKNH_LoadDuLieu_Rut
as
select h.NHID,h.so_ctu,h.ngay_ctu,l.tk as tk_co,h.loai_tien,l.chitiet_tk as chitiet_co,
		h.ty_gia,h.so_ctu,h.hoten,h.noi_dung,h.tk_vat,h.tien_vat,
		h.mauso,h.khautru,h.thang
 
 from NKNH_H h inner join NKNH_L l on h.NHID=l.NHID
 
 
 select * from DM_TIenTe 